When updates are applied to PostgreSQL software, any software components that have been replaced or made unnecessary must be removed.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-72917	PGS9-00-004300	SV-87569r1_rule		Medium

Description
Previous versions of PostgreSQL components that are not removed from the information system after updates have been installed may be exploited by adversaries. Some PostgreSQL installation tools may remove older versions of software automatically from the information system. In other cases, manual review and removal will be required. In planning installations and upgrades, organizations must include steps (automated, manual, or both) to identify and remove the outdated modules. A transition period may be necessary when both the old and the new software are required. This should be taken into account in the planning.

Description

Previous versions of PostgreSQL components that are not removed from the information system after updates have been installed may be exploited by adversaries. Some PostgreSQL installation tools may remove older versions of software automatically from the information system. In other cases, manual review and removal will be required. In planning installations and upgrades, organizations must include steps (automated, manual, or both) to identify and remove the outdated modules. A transition period may be necessary when both the old and the new software are required. This should be taken into account in the planning.

STIG	Date
PostgreSQL 9.x Security Technical Implementation Guide	2020-03-23

Details

Check Text ( C-73051r1_chk )
To check software installed by packages, as the system administrator, run the following command: # RHEL/CENT Systems $ sudo rpm -qa \| grep postgres If multiple versions of postgres are installed but are unused, this is a finding.

Fix Text (F-79361r1_fix)
Use package managers (RPM or apt-get) for installing PostgreSQL. Unused software is removed when updated.